SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 50787: Incorrect results might occur when you are using DB2 temporary tables in a z/OS operating environment

DetailsHotfixAboutRate It

Incorrect results might occur when you use DB2 temporary tables with SAS/ACCESS® Interface to DB2 under z/OS if the following conditions exist:

  • READBUFF>1 is specified in the LIBNAME statement.
  • DBMSTEMP is specified in the LIBNAME statement.
  • A DB2 temporary table is created based on a different DB2 temporary table.

To work around the issue, do one of the following:

  • Do not use the READBUFF>1 LIBNAME option.
  • Use the explicit pass-through facility instead.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.2 TS2M39.4 TS1M1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.